#!/usr/bin/env python
# $Id: test2-9.py df54dec975f4 2012/09/09 20:22:40 pgurumur $
# Copyright (c) 2012 Prabhu Gurumurthy <pgurumur@gmail.com>
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
# WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
# ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
# WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
# ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
#

__version__  = "$Revision: df54dec975f4 $"
__author__   = "$Author: pgurumur $"
__modified__ = "$Date: 2012-09-09 20:22:40Z $"

import optparse

from venya.lib import sql
from venya.lib import ip
from venya.tools import trie

netdot = sql.mysql("netdot", "sirius", "djanet", "oS9XckUcTAHc5rjlcPt1")
ipblock = netdot.ipblock
if ipblock:
   tree = trie.trie()
   count = 0
   for ix in ipblock.q.filter(ipblock.version == 6).order_by(
         ipblock.parent).values(ipblock.address, ipblock.prefix,
               ipblock.version, ipblock.parent, ipblock.id):
      addr = ip.ip(int(ix[0]), prefix = ix[1], version = ix[2])
      tree.add(addr)
      count += 1

   for node in tree:
      print node
